|
Name |
Description: |
Example |
|
Functions: | ||
|
tab |
Is an IF THEN Function (Case command). Example: IF A THEN X, IF B THEN Y Otherwise Z |
tab(Fieldname)(A;B:X;Y;Z) |
|
frmt |
Assigns a certain formatting to the cell. If 13 is listed in the field (fieldname) 13.00 € are provided |
frmt(Fieldname;”###;00 €”) |
|
mid |
11
|
mid(“ABCDE”;2)=“AB” mid(“ABCDE”;2;3)=”BCD” |
|
len |
Determines the length of a character string. |
len(jum.Fieldname)=5 len("")=0 |
|
goto |
Is a goto statement. It allows the creation of loops. Information on the target occurs through variable names of the target line. |
goto(Variablename) |
|
exit |
Immediately cancels a calculation |
exit |
|
Sin |
Calculates the sinus of a number |
sin(45)=0. 85 |
|
Cos |
Calculates the consine of a number |
cos(45)=0.52 |
|
Tan |
Calculates the tangent of a number |
tan(45)=1.61 |
|
Atn |
Calculates the arcus tangent of a number |
atn(45)=1.54 |
|
Exp |
Calculates the sum with any exponent on the basis of 2,71828 |
exp(4)=54.59 |
|
Log |
Returns the naturnal logorithm of a number |
log(45)=3.80 |
|
Sqr |
Pulls the root of a number |
sqr(45)=6.70 |
|
Abs |
Gives the number as an absolute number (=Positive) back |
abs(-45)=45 |
|
abort |
Cancels the calculation and provides an error report . |
abort("Entry is not plausible") |
|
in |
Function tested, if a variable lies in a value area |
10 IN [25 .. 35] = False |
|
Operators: | ||
|
+ |
The "+"-Operator adds two values |
10+3=13 |
|
- |
The "-"-Operator subtracts two values |
10-3=7 |
|
* |
The "*"-Operator multiplies two values |
10*3=30 |
|
/ |
The "/"-Operator divides two values |
10/3=3.33 |
|
\ |
the "\"-Operator divides two values in integers |
10\3=3 |
|
() |
The content of "()"-Operators is calculated first |
(10+3)*10=130 |
|
{} |
The content of "{}"-Operators are shown as a value |
{jum.m} |
|
% |
The "%" Operator delivers the rest of an integer division |
10%3=1 |
|
Platzhalter: | ||
|
jum.x |
Access to the 1st measurement |
jum.x |
|
jum.y |
Access to the 2nd measurement |
jum.y |
|
jum.z |
Access to the 3rd measurement |
jum.z |
|
jum.m |
Access to the quantity |
jum.m |
|
jum.vk |
Access to the SP of the parts list; Careful item-dependent! |
jum.vk |
|
jum.ek |
Access to teh PP; Careful item-dependent! |
jum.ek |